object Form1: TForm1
  Left = 238
  Top = 164
  Width = 927
  Height = 699
  Caption = #26597#35810
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'Tahoma'
  Font.Style = []
  OldCreateOrder = False
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 13
  object PageControl1: TPageControl
    Left = 0
    Top = 67
    Width = 919
    Height = 598
    ActivePage = TabSheet1
    Align = alClient
    TabOrder = 0
    OnChange = PageControl1Change
    object TabSheet1: TTabSheet
      Caption = #20998#27004#23618#25353#19987#26588#38144#21806#27719#24635
      object Panel2: TPanel
        Left = 0
        Top = 0
        Width = 911
        Height = 525
        Align = alClient
        ParentBackground = False
        TabOrder = 0
        object DBGridEh1: TDBGridEh
          Left = 1
          Top = 1
          Width = 909
          Height = 523
          Align = alClient
          AutoFitColWidths = True
          DataSource = DataSource1
          ShowSerialNo = False
          Flat = False
          Font.Charset = ANSI_CHARSET
          Font.Color = clWindowText
          Font.Height = -15
          Font.Name = 'Consolas'
          Font.Style = []
          FooterColor = clWindow
          FooterFont.Charset = DEFAULT_CHARSET
          FooterFont.Color = clWindowText
          FooterFont.Height = -11
          FooterFont.Name = 'Tahoma'
          FooterFont.Style = []
          ImeName = #20013#25991' ('#31616#20307') - '#32654#24335#38190#30424
          OptionsEh = [dghHighlightFocus, dghClearSelection, dghDialogFind]
          ParentFont = False
          TabOrder = 0
          TitleFont.Charset = GB2312_CHARSET
          TitleFont.Color = clWindowText
          TitleFont.Height = -19
          TitleFont.Name = 'Fixedsys'
          TitleFont.Style = [fsBold]
          Columns = <
            item
              EditButtons = <>
              FieldName = 'MFpcode'
              Footers = <>
              Title.Caption = #27004#23618#21495
              Width = 100
            end
            item
              EditButtons = <>
              FieldName = 'SCDMFID'
              Footers = <>
              Title.Caption = #23703#32452#21495
              Width = 100
            end
            item
              EditButtons = <>
              FieldName = 'MFCNAME'
              Footers = <>
              Title.Caption = #23703#32452#21517#31216
              Width = 100
            end
            item
              EditButtons = <>
              FieldName = 'THISXSSR'
              Footers = <>
              Title.Caption = #38144#21806#21512#35745
              Width = 100
            end
            item
              Alignment = taCenter
              EditButtons = <>
              FieldName = 'SCDDATE'
              Footers = <>
              Title.Caption = #26085#26399
              Width = 100
            end>
        end
      end
      object Panel3: TPanel
        Left = 0
        Top = 525
        Width = 911
        Height = 45
        Align = alBottom
        ParentBackground = False
        TabOrder = 1
        object Button1: TButton
          Left = 371
          Top = 10
          Width = 75
          Height = 25
          Caption = #26597#35810
          TabOrder = 0
          OnClick = Button1Click
        end
        object Button2: TButton
          Left = 469
          Top = 10
          Width = 75
          Height = 25
          Caption = #23548#20986
          TabOrder = 1
          OnClick = Button2Click
        end
      end
    end
    object TabSheet2: TTabSheet
      Caption = #25353#21830#21697#20998#31867#26376#32479#35745
      ImageIndex = 1
      object Panel5: TPanel
        Left = 0
        Top = 0
        Width = 911
        Height = 525
        Align = alClient
        ParentBackground = False
        TabOrder = 0
        object DBGridEh2: TDBGridEh
          Left = 1
          Top = 1
          Width = 909
          Height = 523
          Align = alClient
          DataSource = DataSource2
          ShowSerialNo = False
          Flat = False
          Font.Charset = ANSI_CHARSET
          Font.Color = clWindowText
          Font.Height = -15
          Font.Name = 'Consolas'
          Font.Style = []
          FooterColor = clWindow
          FooterFont.Charset = DEFAULT_CHARSET
          FooterFont.Color = clWindowText
          FooterFont.Height = -11
          FooterFont.Name = 'Tahoma'
          FooterFont.Style = []
          ImeName = #20013#25991' ('#31616#20307') - '#32654#24335#38190#30424
          Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgConfirmDelete, dgCancelOnExit]
          ParentFont = False
          TabOrder = 0
          TitleFont.Charset = DEFAULT_CHARSET
          TitleFont.Color = clWindowText
          TitleFont.Height = -11
          TitleFont.Name = 'Tahoma'
          TitleFont.Style = []
        end
      end
      object Panel6: TPanel
        Left = 0
        Top = 525
        Width = 911
        Height = 45
        Align = alBottom
        ParentBackground = False
        TabOrder = 1
        object Button3: TButton
          Left = 371
          Top = 10
          Width = 75
          Height = 25
          Caption = #26597#35810
          TabOrder = 0
          OnClick = Button3Click
        end
        object Button4: TButton
          Left = 469
          Top = 10
          Width = 75
          Height = 25
          Caption = #23548#20986
          TabOrder = 1
          OnClick = Button4Click
        end
        object Memo3: TMemo
          Left = 696
          Top = 12
          Width = 81
          Height = 21
          ImeName = #20013#25991' ('#31616#20307') - '#32654#24335#38190#30424
          Lines.Strings = (
            'Memo3')
          TabOrder = 2
          Visible = False
          OnDblClick = Memo3DblClick
        end
      end
    end
    object TabSheet3: TTabSheet
      Caption = #26412#24180#21508#27004#23618#20998#19987#26588#19982#21435#24180#24180#27719#24635#23545#27604
      ImageIndex = 2
      object Panel1: TPanel
        Left = 0
        Top = 529
        Width = 911
        Height = 41
        Align = alBottom
        ParentBackground = False
        TabOrder = 0
        object Button5: TButton
          Left = 416
          Top = 8
          Width = 75
          Height = 25
          Caption = #29983#25104
          TabOrder = 0
          OnClick = Button5Click
        end
        object Button6: TButton
          Left = 512
          Top = 8
          Width = 75
          Height = 25
          Caption = 'Button6'
          TabOrder = 1
          OnClick = Button6Click
        end
      end
      object Panel4: TPanel
        Left = 0
        Top = 41
        Width = 911
        Height = 488
        Align = alClient
        ParentBackground = False
        TabOrder = 1
        object DBGrid1: TDBGrid
          Left = 1
          Top = 1
          Width = 909
          Height = 486
          Align = alClient
          DataSource = DataSource3
          ImeName = #20013#25991' ('#31616#20307') - '#32654#24335#38190#30424
          TabOrder = 0
          TitleFont.Charset = DEFAULT_CHARSET
          TitleFont.Color = clWindowText
          TitleFont.Height = -11
          TitleFont.Name = 'Tahoma'
          TitleFont.Style = []
        end
        object Memo2: TMemo
          Left = 728
          Top = 184
          Width = 169
          Height = 89
          ImeName = #20013#25991' ('#31616#20307') - '#32654#24335#38190#30424
          Lines.Strings = (
            'TRANSFORM sum(THISXSSR) AS '
            'XSSR SELECT '
            'MFPCODE,SCDMFID,MFCNAME '
            'FROM CROSSXS GROUP BY '
            'MFPCODE,SCDMFID,MFCNAME '
            'PIVOT SCDDATE')
          TabOrder = 1
          Visible = False
        end
        object Memo1: TMemo
          Left = 728
          Top = 8
          Width = 161
          Height = 161
          ImeName = #20013#25991' ('#31616#20307') - '#32654#24335#38190#30424
          Lines.Strings = (
            'SELECT mfpcode,scdmfid, '
            'mfcname, SUM (thisxssr) AS '
            'thisxssr, monthaa AS scddate'
            '    FROM (SELECT   scdmkt, '
            'scdmfid, TO_CHAR (scddate, '
            #39'yyyy'#39') monthaa,'
            '                   SUM (NVL (xssr + '
            'pfsr, 0)) thisxssr, '
            'b.mfcname,b.mfpcode'
            '              FROM '
            'dbusrmkt205.salecostday a, '
            'dbusrpub.manaframe b'
            '             WHERE a.scdmfid = '
            'b.mfcode'
            '               AND b.mffcode = '
            #39'205'#39
            '               AND scddate >= '
            'TO_DATE (:date1, '#39'YYYY-MM-'
            'DD'#39')'
            '               AND scddate <= '
            'TO_DATE (:date3, '#39'YYYY-MM-'
            'DD'#39')'
            '               AND a.scdmfid = '
            'b.mfcode'
            '          GROUP BY scdmkt, '
            'scdmfid, scddate, '
            'b.mfcname,b.mfpcode)'
            'GROUP BY scdmfid, monthaa, '
            'mfcname,mfpcode'
            'union'
            'SELECT mfpcode,scdmfid, '
            'mfcname, SUM (thisxssr) AS '
            'thisxssr, monthaa AS scddate'
            '    FROM (SELECT   scdmkt, '
            'scdmfid, TO_CHAR (scddate, '
            #39'yyyymm'#39') monthaa,'
            '                   SUM (NVL (xssr + '
            'pfsr, 0)) thisxssr, '
            'b.mfcname,b.mfpcode'
            '              FROM '
            'dbusrmkt205.salecostday a, '
            'dbusrpub.manaframe b'
            '             WHERE a.scdmfid = '
            'b.mfcode'
            '               AND b.mffcode = '
            #39'205'#39
            '               AND scddate >= '
            'TO_DATE (:date2, '#39'YYYY-MM-'
            'DD'#39')'
            '               AND scddate <= '
            'TO_DATE (:date3, '#39'YYYY-MM-'
            'DD'#39')'
            '               AND a.scdmfid = '
            'b.mfcode'
            '          GROUP BY scdmkt, '
            'scdmfid, scddate, '
            'b.mfcname,b.mfpcode)'
            'GROUP BY scdmfid, monthaa, '
            'mfcname,mfpcode')
          TabOrder = 2
          Visible = False
        end
      end
      object Panel7: TPanel
        Left = 0
        Top = 0
        Width = 911
        Height = 41
        Align = alTop
        Font.Charset = ANSI_CHARSET
        Font.Color = clWindowText
        Font.Height = -15
        Font.Name = 'Consolas'
        Font.Style = [fsBold]
        ParentBackground = False
        ParentFont = False
        TabOrder = 2
        object Label2: TLabel
          Left = 5
          Top = 13
          Width = 85
          Height = 18
          Caption = #21435#24180#26085#26399#65306
        end
        object Label3: TLabel
          Left = 230
          Top = 13
          Width = 85
          Height = 18
          Caption = #20170#24180#26085#26399#65306
        end
        object Shape2: TShape
          Left = 430
          Top = 20
          Width = 21
          Height = 3
          Brush.Color = clBlack
        end
        object DateTimePicker3: TDateTimePicker
          Left = 91
          Top = 8
          Width = 110
          Height = 26
          Date = 40213.653870451390000000
          Time = 40213.653870451390000000
          ImeName = #20013#25991' ('#31616#20307') - '#32654#24335#38190#30424
          TabOrder = 0
        end
        object DateTimePicker4: TDateTimePicker
          Left = 316
          Top = 8
          Width = 110
          Height = 26
          Date = 40213.653870451390000000
          Time = 40213.653870451390000000
          ImeName = #20013#25991' ('#31616#20307') - '#32654#24335#38190#30424
          TabOrder = 1
        end
        object DateTimePicker5: TDateTimePicker
          Left = 458
          Top = 8
          Width = 110
          Height = 26
          Date = 40213.654044062500000000
          Time = 40213.654044062500000000
          ImeName = #20013#25991' ('#31616#20307') - '#32654#24335#38190#30424
          TabOrder = 2
        end
      end
    end
  end
  object GroupBox3: TGroupBox
    Left = 0
    Top = 0
    Width = 919
    Height = 67
    Align = alTop
    Caption = #26597#35810#26465#20214
    Font.Charset = ANSI_CHARSET
    Font.Color = clWindowText
    Font.Height = -19
    Font.Name = 'Consolas'
    Font.Style = [fsBold]
    ParentFont = False
    TabOrder = 1
    object Label7: TLabel
      Left = 8
      Top = 31
      Width = 51
      Height = 19
      Caption = #26085#26399#65306
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Height = -16
      Font.Name = 'Tahoma'
      Font.Style = [fsBold]
      ParentFont = False
    end
    object Label8: TLabel
      Left = 349
      Top = 31
      Width = 51
      Height = 19
      Caption = #27004#23618#65306
      Font.Charset = DEFAULT_CHARSET
      Font.Color = clWindowText
      Font.Height = -16
      Font.Name = 'Tahoma'
      Font.Style = [fsBold]
      ParentFont = False
    end
    object Shape1: TShape
      Left = 189
      Top = 41
      Width = 21
      Height = 3
      Brush.Color = clBlack
    end
    object DateTimePicker2: TDateTimePicker
      Left = 216
      Top = 27
      Width = 129
      Height = 30
      Date = 40061.751591608790000000
      Time = 40061.751591608790000000
      Font.Charset = ANSI_CHARSET
      Font.Color = clWindowText
      Font.Height = -19
      Font.Name = 'Consolas'
      Font.Style = [fsBold]
      ImeName = #20013#25991' ('#31616#20307') - '#32654#24335#38190#30424
      ParentFont = False
      TabOrder = 0
    end
    object DateTimePicker1: TDateTimePicker
      Left = 56
      Top = 27
      Width = 129
      Height = 30
      Date = 40061.751573159720000000
      Time = 40061.751573159720000000
      Font.Charset = ANSI_CHARSET
      Font.Color = clWindowText
      Font.Height = -19
      Font.Name = 'Consolas'
      Font.Style = [fsBold]
      ImeName = #20013#25991' ('#31616#20307') - '#32654#24335#38190#30424
      ParentFont = False
      TabOrder = 1
    end
    object ComboBox1: TComboBox
      Left = 397
      Top = 25
      Width = 116
      Height = 30
      Style = csDropDownList
      Font.Charset = ANSI_CHARSET
      Font.Color = clWindowText
      Font.Height = -19
      Font.Name = 'Consolas'
      Font.Style = [fsBold]
      ImeName = #20013#25991' ('#31616#20307') - '#32654#24335#38190#30424
      ItemHeight = 22
      ParentFont = False
      TabOrder = 2
      OnSelect = ComboBox1Select
      Items.Strings = (
        ''
        #19968#27004#21830#22330
        #20108#27004#21830#22330
        #19977#27004#21830#22330
        #22235#27004#21830#22330
        #20116#27004#21830#22330)
    end
    object GroupBox2: TGroupBox
      Left = 520
      Top = 16
      Width = 257
      Height = 45
      Caption = #26465#20214
      Font.Charset = ANSI_CHARSET
      Font.Color = clWindowText
      Font.Height = -14
      Font.Name = 'Consolas'
      Font.Style = [fsBold]
      ParentFont = False
      TabOrder = 3
      Visible = False
      object RadioButton3: TRadioButton
        Left = 16
        Top = 21
        Width = 65
        Height = 17
        Caption = #22823#31867
        TabOrder = 0
      end
      object RadioButton4: TRadioButton
        Left = 99
        Top = 21
        Width = 65
        Height = 17
        Caption = #20013#31867
        TabOrder = 1
      end
      object RadioButton5: TRadioButton
        Left = 179
        Top = 21
        Width = 65
        Height = 17
        Caption = #23567#31867
        TabOrder = 2
      end
    end
    object GroupBox1: TGroupBox
      Left = 520
      Top = 16
      Width = 391
      Height = 45
      Caption = #26465#20214
      Font.Charset = ANSI_CHARSET
      Font.Color = clWindowText
      Font.Height = -14
      Font.Name = 'Consolas'
      Font.Style = [fsBold]
      ParentFont = False
      TabOrder = 4
      object Label1: TLabel
        Left = 237
        Top = 19
        Width = 60
        Height = 17
        Caption = #23703#32452#21495#65306
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Height = -14
        Font.Name = 'Tahoma'
        Font.Style = [fsBold]
        ParentFont = False
      end
      object RadioButton1: TRadioButton
        Left = 88
        Top = 19
        Width = 74
        Height = 17
        Caption = #26085#21512#35745
        TabOrder = 0
      end
      object RadioButton2: TRadioButton
        Left = 160
        Top = 19
        Width = 73
        Height = 17
        Caption = #26376#21512#35745
        TabOrder = 1
      end
      object ComboBox2: TComboBox
        Left = 12
        Top = 16
        Width = 65
        Height = 25
        Style = csDropDownList
        Font.Charset = DEFAULT_CHARSET
        Font.Color = clWindowText
        Font.Height = -14
        Font.Name = 'Tahoma'
        Font.Style = [fsBold]
        ImeName = #20013#25991' ('#31616#20307') - '#32654#24335#38190#30424
        ItemHeight = 17
        ItemIndex = 0
        ParentFont = False
        TabOrder = 2
        Text = #19987#26588
        OnSelect = ComboBox2Select
        Items.Strings = (
          #19987#26588
          #27004#23618)
      end
      object Edit1: TEdit
        Left = 292
        Top = 14
        Width = 88
        Height = 25
        ImeName = #20013#25991' ('#31616#20307') - '#32654#24335#38190#30424
        TabOrder = 3
      end
    end
  end
  object OraQuery1: TOraQuery
    SQL.Strings = (
      'select mfcname,sum(thisxssr),monthaa from('
      
        '         SELECT SCDMKT, SCDMFID,to_char(SCDDATE,'#39'YYYYMM'#39') montha' +
        'a, SUM(NVL(XSSR + PFSR, 0)) THISXSSR,b.mfcname'
      '          FROM DBUSRMKT205.SALECOSTDAY a,DBUSRPUB.MANAFRAME b'
      
        '        WHERE a.scdmfid=b.mfcode and b.mffcode='#39'205'#39' and mfpcode' +
        '='#39'20502'#39' and scddate>= '
      ''
      
        'TO_DATE('#39'2008-01'#39', '#39'YYYY-MM'#39') and scddate<= TO_DATE('#39'2008-12'#39', '#39 +
        'YYYY-MM'#39') '
      ''
      'and a.scdmfid=b.mfcode'
      
        '        -- WHERE SALECOSTDAY.SCDDATE = TO_DATE('#39'2009-01-31'#39', '#39'YY' +
        'YY-MM-DD'#39')'
      '         GROUP BY SCDMKT, SCDMFID,SCDDATE,b.mfcname'
      '         ) group by monthaa,mfcname')
    Left = 144
    Top = 209
  end
  object DataSource1: TDataSource
    DataSet = OraQuery1
    Left = 112
    Top = 208
  end
  object SaveDialog1: TSaveDialog
    DefaultExt = 'xls'
    Filter = '*.xls|*.xls'
    Left = 176
    Top = 209
  end
  object OraQuery2: TOraQuery
    SQL.Strings = (
      '/* Formatted on 2010/01/02 11:03 (Formatter Plus v4.8.8) */'
      'SELECT   tm5.catcname name1, tm4.*'
      '    FROM (SELECT tm3.catcname name2, tm2.*'
      '            FROM (SELECT tm1.catcname, tm.*'
      
        '                    FROM (SELECT   a.sabm, a.sadl, a.sazl, a.sac' +
        'atcode,'
      '                                   SUM (CASE'
      
        '                                           WHEN sadate = TO_DATE' +
        ' ('#39'2009-12-1'#39', '#39'yyyy-mm-dd'#39')'
      '                                              THEN thistoday'
      '                                           ELSE 0'
      '                                        END'
      '                                       ) AS "20091201",'
      '                                   SUM (CASE'
      
        '                                           WHEN sadate = TO_DATE' +
        ' ('#39'2009-12-2'#39', '#39'yyyy-mm-dd'#39')'
      '                                              THEN thistoday'
      '                                           ELSE 0'
      '                                        END'
      '                                       ) AS "20091202",'
      '                                   SUM (CASE'
      
        '                                           WHEN sadate = TO_DATE' +
        ' ('#39'2009-12-3'#39', '#39'yyyy-mm-dd'#39')'
      '                                              THEN thistoday'
      '                                           ELSE 0'
      '                                        END'
      '                                       ) AS "20091203"'
      '                              FROM (SELECT *'
      '                                      FROM salecostday_a315'
      '                                     WHERE sabm = '#39'20501'#39
      
        '                                       AND sadate >= TO_DATE ('#39'2' +
        '009-12-01'#39', '#39'yyyy-mm-dd'#39')'
      
        '                                       AND sadate <= TO_DATE ('#39'2' +
        '009-12-03'#39', '#39'yyyy-mm-dd'#39')'
      '                                       AND ((   thistoday <> 0'
      '                                             OR lasttoday <> 0'
      '                                             OR thisxssr <> 0'
      '                                             OR lastxssr <> 0'
      '                                             OR thismonxssr <> 0'
      '                                             OR lastmonxssr <> 0'
      
        '                                             OR lastyearxssr <> ' +
        '0'
      '                                            )'
      '                                           )) a'
      '                             WHERE a.sabm = '#39'20501'#39
      
        '                          GROUP BY a.sabm, a.sadl, a.sazl, a.sac' +
        'atcode) tm,'
      '                         goodscat tm1'
      '                   WHERE tm.sacatcode = tm1.catcode) tm2,'
      '                 goodscat tm3'
      '           WHERE tm2.sazl = tm3.catcode) tm4,'
      '         goodscat tm5'
      '   WHERE tm4.sadl = tm5.catcode'
      'ORDER BY tm4.sadl, tm4.sazl, tm4.sacatcode')
    Left = 352
    Top = 128
  end
  object DataSource2: TDataSource
    AutoEdit = False
    DataSet = OraQuery2
    Left = 384
    Top = 128
  end
  object OraSession1: TOraSession
    Username = 'dbusrmkt205'
    Password = 'futuremkt'
    Server = 'M205_DB'
    Connected = True
    ConnectDialog = ConnectDialog1
    LoginPrompt = False
    Left = 204
    Top = 115
  end
  object ConnectDialog1: TConnectDialog
    SavePassword = True
    Caption = 'Connect'
    UsernameLabel = 'User Name'
    PasswordLabel = 'Password'
    ServerLabel = 'Server'
    ConnectButton = 'Connect'
    CancelButton = 'Cancel'
    Left = 460
    Top = 131
  end
  object OraQuery3: TOraQuery
    Session = OraSession1
    SQL.Strings = (
      
        'SELECT mfpcode,scdmfid, mfcname, SUM (thisxssr) AS thisxssr, mon' +
        'thaa AS scddate'
      
        '    FROM (SELECT   scdmkt, scdmfid, TO_CHAR (scddate, '#39'yyyy'#39') mo' +
        'nthaa,'
      
        '                   SUM (NVL (xssr + pfsr, 0)) thisxssr, b.mfcnam' +
        'e,b.mfpcode'
      
        '              FROM dbusrmkt205.salecostday a, dbusrpub.manaframe' +
        ' b'
      '             WHERE a.scdmfid = b.mfcode'
      '               AND b.mffcode = '#39'205'#39
      
        '               AND scddate >= TO_DATE ('#39'2008-01-01'#39', '#39'YYYY-MM-DD' +
        #39')'
      
        '               AND scddate <= TO_DATE ('#39'2009-12-31'#39', '#39'YYYY-MM-DD' +
        #39')'
      '               AND a.scdmfid = b.mfcode'
      
        '          GROUP BY scdmkt, scdmfid, scddate, b.mfcname,b.mfpcode' +
        ')'
      'GROUP BY scdmfid, monthaa, mfcname,mfpcode'
      'union'
      
        'SELECT mfpcode,scdmfid, mfcname, SUM (thisxssr) AS thisxssr, mon' +
        'thaa AS scddate'
      
        '    FROM (SELECT   scdmkt, scdmfid, TO_CHAR (scddate, '#39'yyyymm'#39') ' +
        'monthaa,'
      
        '                   SUM (NVL (xssr + pfsr, 0)) thisxssr, b.mfcnam' +
        'e,b.mfpcode'
      
        '              FROM dbusrmkt205.salecostday a, dbusrpub.manaframe' +
        ' b'
      '             WHERE a.scdmfid = b.mfcode'
      '               AND b.mffcode = '#39'205'#39
      
        '               AND scddate >= TO_DATE ('#39'2009-01-01'#39', '#39'YYYY-MM-DD' +
        #39')'
      
        '               AND scddate <= TO_DATE ('#39'2009-12-31'#39', '#39'YYYY-MM-DD' +
        #39')'
      '               AND a.scdmfid = b.mfcode'
      
        '          GROUP BY scdmkt, scdmfid, scddate, b.mfcname,b.mfpcode' +
        ')'
      'GROUP BY scdmfid, monthaa, mfcname,mfpcode')
    Left = 436
    Top = 363
  end
  object ADOTable1: TADOTable
    Left = 492
    Top = 363
  end
  object ADOQuery1: TADOQuery
    ConnectionString = 
      'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=XS.mdb;Persist Secu' +
      'rity Info=False'
    Parameters = <>
    Left = 396
    Top = 363
  end
  object ADOQuery2: TADOQuery
    ConnectionString = 
      'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=XS.mdb;Persist Secu' +
      'rity Info=False'
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      'TRANSFORM sum(THISXSSR) AS XSSR SELECT '
      'MFPCODE,SCDMFID,MFCNAME '
      'FROM CROSSXS GROUP BY '
      'MFPCODE,SCDMFID,MFCNAME '
      'PIVOT SCDDATE')
    Left = 308
    Top = 372
  end
  object DataSource3: TDataSource
    DataSet = ADOQuery2
    Left = 348
    Top = 372
  end
end
